FRMCARINA025 (LIMIT_FETCH_GKEY)

Specifies the maximum number of records N4 can fetch from the database. This is different from the maximum number of records that are displayed in a list view at any given time. To restrict the number of records visible in a list view, you must configure FRMCARINA019 (MAX_TABLE_ROWS) (on page 1).

Default: 50000

Minimum: 100

Maximum: 1000000

When the record count for a table view exceeds the threshold specified using FRMCARINA025, N4 displays the following message:

[#] rows found. Too many rows to display. Change your filter criteria to narrow your search.

To override the threshold value:

  • For all the users: Update the value for the FRMCARINA025 configuration setting.

  • For a specific user account: Update the value in the Fetch Row Limit field on the Behaviors tab in the User Preferences form.

  • See also, FRMCARINA019 (MAX_TABLE_ROWS) (on page 1).